It looks like your having a connection problem rather than an ASP problem. Here are a few things that you can try:
Have you tried opening a database on the server that you are having trouble connecting to? Sometimes you need to accept a certificate from the server in order to populate the database drop down list when creating a DSN, plus it will tell you if your having any connection problems in your Notes Client.
Try using Microsoft's ODBC Test Program to establish a connection using the DSN that you created. You can get it as part of their ODBC SDK and should be available in the latest MDAC SDKs at
http://www.microsoft.com/data .
Here's a thread that talks about using IIS with the NotesSQL driver:
http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/b2df362dfd1dff0f85256a8d006f4015?OpenDocument
There is a patch available for the NotesSQL 3.02 driver that addresses a crash when using ASP. You can get this through Technical Support or if you post an email address I'll send it to you.
Hope this helps,
Paul